/*
 Navicat Premium Data Transfer

 Source Server         : local_SQLService
 Source Server Type    : SQL Server
 Source Server Version : 15002000
 Source Host           : .:1433
 Source Catalog        : Lanbt
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 15002000
 File Encoding         : 65001

 Date: 03/02/2023 14:22:32
*/


-- ----------------------------
-- Table structure for LANBT_BLOB_TRIGGERS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_BLOB_TRIGGERS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_BLOB_TRIGGERS]
GO

CREATE TABLE [dbo].[LANBT_BLOB_TRIGGERS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [BLOB_DATA] varbinary(max)  NULL
)
GO

ALTER TABLE [dbo].[LANBT_BLOB_TRIGGERS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_BLOB_TRIGGERS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_BLOB_TRIGGERS',
'COLUMN', N'TRIGGER_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_BLOB_TRIGGERS',
'COLUMN', N'TRIGGER_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Blob数据块',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_BLOB_TRIGGERS',
'COLUMN', N'BLOB_DATA'
GO

EXEC sp_addextendedproperty
'MS_Description', N'以Blob 类型存储的触发器。',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_BLOB_TRIGGERS'
GO


-- ----------------------------
-- Records of LANBT_BLOB_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for LANBT_CALENDARS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_CALENDARS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_CALENDARS]
GO

CREATE TABLE [dbo].[LANBT_CALENDARS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CALENDAR_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CALENDAR] varbinary(max)  NOT NULL
)
GO

ALTER TABLE [dbo].[LANBT_CALENDARS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CALENDARS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'日历名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CALENDARS',
'COLUMN', N'CALENDAR_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'日历',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CALENDARS',
'COLUMN', N'CALENDAR'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存放日历信息，quartz可配置一个日历来指定一个时间范围。',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CALENDARS'
GO


-- ----------------------------
-- Records of LANBT_CALENDARS
-- ----------------------------

-- ----------------------------
-- Table structure for LANBT_CRON_TRIGGERS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_CRON_TRIGGERS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_CRON_TRIGGERS]
GO

CREATE TABLE [dbo].[LANBT_CRON_TRIGGERS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CRON_EXPRESSION] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TIME_ZONE_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[LANBT_CRON_TRIGGERS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CRON_TRIGGERS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CRON_TRIGGERS',
'COLUMN', N'TRIGGER_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CRON_TRIGGERS',
'COLUMN', N'TRIGGER_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'CRON_表达式',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CRON_TRIGGERS',
'COLUMN', N'CRON_EXPRESSION'
GO

EXEC sp_addextendedproperty
'MS_Description', N'时间区域ID',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CRON_TRIGGERS',
'COLUMN', N'TIME_ZONE_ID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存放cron类型的触发器。',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_CRON_TRIGGERS'
GO


-- ----------------------------
-- Records of LANBT_CRON_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for LANBT_FIRED_TRIGGERS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_FIRED_TRIGGERS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_FIRED_TRIGGERS]
GO

CREATE TABLE [dbo].[LANBT_FIRED_TRIGGERS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ENTRY_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [INSTANCE_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [FIRED_TIME] bigint  NOT NULL,
  [SCHED_TIME] bigint  NOT NULL,
  [PRIORITY] int  NOT NULL,
  [STATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [JOB_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [JOB_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IS_NONCONCURRENT] bit  NULL,
  [REQUESTS_RECOVERY] bit  NULL
)
GO

ALTER TABLE [dbo].[LANBT_FIRED_TRIGGERS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组织id',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'ENTRY_ID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'TRIGGER_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'TRIGGER_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'实例名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'INSTANCE_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发时间',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'FIRED_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'计划时间',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'SCHED_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权重',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'PRIORITY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'STATE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'作业名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'JOB_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'作业群组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'JOB_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否并行',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'IS_NONCONCURRENT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否要求唤醒',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS',
'COLUMN', N'REQUESTS_RECOVERY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存放已触发的触发器',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_FIRED_TRIGGERS'
GO


-- ----------------------------
-- Records of LANBT_FIRED_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for LANBT_JOB_DETAILS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_JOB_DETAILS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_JOB_DETAILS]
GO

CREATE TABLE [dbo].[LANBT_JOB_DETAILS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [JOB_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [JOB_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DESCRIPTION] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [JOB_CLASS_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [IS_DURABLE] bit  NOT NULL,
  [IS_NONCONCURRENT] bit  NOT NULL,
  [IS_UPDATE_DATA] bit  NOT NULL,
  [REQUESTS_RECOVERY] bit  NOT NULL,
  [JOB_DATA] varbinary(max)  NULL
)
GO

ALTER TABLE [dbo].[LANBT_JOB_DETAILS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度器名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'JOB_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务群组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'JOB_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'说明',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'DESCRIPTION'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务class全路径',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'JOB_CLASS_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否可持久',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'IS_DURABLE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否当前',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'IS_NONCONCURRENT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否更新数据',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'IS_UPDATE_DATA'
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求恢复',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'REQUESTS_RECOVERY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务数据',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS',
'COLUMN', N'JOB_DATA'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存放一个jobDetail信息。',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_JOB_DETAILS'
GO


-- ----------------------------
-- Records of LANBT_JOB_DETAILS
-- ----------------------------

-- ----------------------------
-- Table structure for LANBT_LOCKS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_LOCKS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_LOCKS]
GO

CREATE TABLE [dbo].[LANBT_LOCKS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [LOCK_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[LANBT_LOCKS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_LOCKS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'锁名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_LOCKS',
'COLUMN', N'LOCK_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存储程序的悲观锁的信息(假如使用了悲观锁)。',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_LOCKS'
GO


-- ----------------------------
-- Records of LANBT_LOCKS
-- ----------------------------
INSERT INTO [dbo].[LANBT_LOCKS] ([SCHED_NAME], [LOCK_NAME]) VALUES (N'QuartzScheduler', N'STATE_ACCESS')
GO


-- ----------------------------
-- Table structure for LANBT_PAUSED_TRIGGER_GRPS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_PAUSED_TRIGGER_GRPS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_PAUSED_TRIGGER_GRPS]
GO

CREATE TABLE [dbo].[LANBT_PAUSED_TRIGGER_GRPS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[LANBT_PAUSED_TRIGGER_GRPS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_PAUSED_TRIGGER_GRPS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_PAUSED_TRIGGER_GRPS',
'COLUMN', N'TRIGGER_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存放暂停掉的触发器。',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_PAUSED_TRIGGER_GRPS'
GO


-- ----------------------------
-- Records of LANBT_PAUSED_TRIGGER_GRPS
-- ----------------------------

-- ----------------------------
-- Table structure for lanbt_power
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[lanbt_power]') AND type IN ('U'))
	DROP TABLE [dbo].[lanbt_power]
GO

CREATE TABLE [dbo].[lanbt_power] (
  [ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [MenuCode] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ParentID] int  NOT NULL,
  [PowerType] int  NOT NULL,
  [IconUrl] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Sort] int  NOT NULL,
  [LineUrl] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Level] int  NOT NULL,
  [Path] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModificaTime] datetime  NOT NULL,
  [ModifiedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IsDelete] bit  NOT NULL,
  [IsMenuShow] bit  NOT NULL,
  [IsEnable] bit  NOT NULL,
  [Descript] varchar(2000) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[lanbt_power] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限名称',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'Name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单编码，用于后端权限控制',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'MenuCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单父节点ID，方便递归遍历菜单',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'ParentID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'节点类型，可以是文件夹、页面或者按钮类型',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'PowerType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图标URL',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'IconUrl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'Sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'页面对应的地址，如果是文件夹或者按钮类型，可以为空',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'LineUrl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单树的层次，以便于查询指定层级的菜单',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'Level'
GO

EXEC sp_addextendedproperty
'MS_Description', N'树id的路径，主要用于存放从根节点到当前树的父节点的路径，逗号分隔，想要找父节点会特别快',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'Path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否显示菜单',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'IsMenuShow'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否启用',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'IsEnable'
GO

EXEC sp_addextendedproperty
'MS_Description', N'说明',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power',
'COLUMN', N'Descript'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_power'
GO


-- ----------------------------
-- Records of lanbt_power
-- ----------------------------
INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'0143e9e4-39e5-4d24-b851-0742839021f7', N'权限批量删除', N'SystemManagerAction:DeletePowerByIds', N'4', N'3', NULL, N'18', NULL, N'3', N'1,4', N'2022-12-12 15:04:10.330', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 15:04:10.330', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'01973ee4-f1b8-447a-9ac6-ea1e0fb525f0', N'权限修改', N'SystemManagerAction:UpdatePower', N'4', N'3', NULL, N'19', NULL, N'3', N'1,4', N'2022-12-12 15:04:34.120', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 15:04:34.120', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'046db109-b057-4aa7-afe3-b2b310e3e8d8', N'22', N'22', N'0', N'1', N'', N'39', N'', N'1', N'', N'2023-01-05 15:50:15.073', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 15:50:21.410', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'0540986c-99ae-4a1c-8604-ea156e8bc542', N'测试按钮', N'HomeAction:test', N'20', N'3', N'', N'51', N'', N'2', N'20', N'2023-01-13 10:49:48.653', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 10:49:48.653', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'05931736-53ca-41c1-a60b-e6dda5b1d559', N'显示/隐藏菜单', N'SystemManagerAction:UpdateMenuShowOrHide', N'4', N'3', N'', N'52', N'', N'3', N'1,4', N'2023-01-13 11:48:32.953', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 11:48:32.953', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'0da4faf3-a1ea-4ee0-8062-b1b30bff8f88', N'管理员列表', N'', N'1', N'2', N'layui-icon-user', N'2', N'/SystemManager/UsersList', N'2', N'1', N'2022-12-12 14:45:13.050', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-30 09:53:12.280', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'13ac3d60-5a84-4e3c-bfbe-832750d08427', N'角色列表-查看', N'SystemManagerAction:QueryPagesRole,SystemManagerAction:QueryRolePowerTreedata', N'3', N'4', N'', N'24', N'', N'3', N'1,3', N'2022-12-12 16:37:01.653', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-05 14:36:36.720', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'14848bc6-49b6-47ef-8c06-da75c2e10c88', N'创建表', N'SystemManagerAction:CreateTables', N'45', N'3', N'', N'47', N'', N'3', N'44,45', N'2023-01-11 15:35:57.533', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 14:02:08.083', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'18a81b2a-5a5a-4204-9504-010e08753fdc', N'任务列表-查看', N'QuartzAction:QueryJobDetailList,QuartzAction:GetJobDetail', N'29', N'4', N'', N'28', N'', N'3', N'27,29', N'2023-01-05 14:36:11.107', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:39:30.800', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'199edc83-db7d-42cf-8f03-41aa9d4eb246', N'角色单个删除', N'SystemManagerAction:DeleteById', N'3', N'3', NULL, N'12', NULL, N'3', N'1,3', N'2022-12-12 14:59:37.340', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 14:59:37.340', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'1b1f2610-0e21-4229-a5a4-7b89cdd3a620', N'用户修改', N'SystemManagerAction:UpdateUser', N'2', N'3', NULL, N'8', NULL, N'3', N'1,2', N'2022-12-12 14:54:35.873', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 14:54:35.873', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'1c9f2111-6583-4115-9299-58337ddd6cc7', N'新增', N'QuartzAction:InsertJob', N'29', N'3', N'', N'30', N'', N'3', N'27,29', N'2023-01-05 14:40:09.823', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:40:09.823', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'23130b38-593c-4fb4-9fb7-1bdcd3e607f3', N'权限列表-查看', N'SystemManagerAction:GetPowerById,SystemManagerAction:QueryPagedPowerList,SystemManagerAction:QuerySelectList', N'4', N'4', N'', N'25', N'', N'3', N'1,4', N'2022-12-12 16:37:17.153', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-05 14:36:44.963', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'2ace8212-7677-45ea-a1eb-f9a3e8168fbe', N'修改', N'QuartzAction:UpdateJob', N'29', N'3', N'', N'31', N'', N'3', N'27,29', N'2023-01-05 14:40:33.630', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:43:36.040', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'2bdf65a3-0181-4b13-8705-4423b00ccb7c', N'用户单个删除', N'SystemManagerAction:DeleteOne', N'2', N'3', NULL, N'6', NULL, N'3', N'1,2', N'2022-12-12 14:53:46.777', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 14:53:46.777', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'33d140d5-463c-4a5d-9b40-5c8e6381e00f', N'222调度', N'33', N'0', N'1', N'', N'37', N'', N'1', N'', N'2023-01-05 15:45:37.783', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 15:49:59.820', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'3848f567-3b03-46f8-90b1-6c0c4d4dca7c', N'权限管理', NULL, N'1', N'2', N'layui-icon-auz', N'4', N'/SystemManager/PowerList', N'2', N'1', N'2022-12-12 14:48:53.807', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-13 16:00:30.477', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'3faad7f5-1841-4c26-a1c8-1f3da6f070f9', N'获取当前登录用户', N'HomeAction:GetCurrentUser', N'20', N'3', NULL, N'22', NULL, N'2', N'20', N'2022-12-12 15:53:01.967', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-12 09:35:03.477', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'421944ab-f9b3-4025-ac6a-f2b45021dbdc', N'添加角色', N'SystemManagerAction:Insert', N'3', N'3', NULL, N'11', NULL, N'3', N'1,3', N'2022-12-12 14:59:14.413', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 14:59:14.413', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'51883cda-3e89-4bcb-9d06-4b4281eca485', N'权限单个删除', N'SystemManagerAction:DeletePowerById', N'4', N'3', NULL, N'17', NULL, N'3', N'1,4', N'2022-12-12 15:03:52.670', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 15:03:52.670', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'51d3fdea-03e4-44e1-bfaf-a42beaea836d', N'查看', N'configaction:getsystemconfig', N'40', N'4', N'', N'41', N'', N'3', N'27,40', N'2023-01-11 15:30:43.940', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-02-03 13:13:10.133', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'529bba46-c5cc-4c89-844f-f9bbfa972634', N'添加超级管理员', N'SystemManagerAction:AddAdmin', N'45', N'3', N'', N'48', N'', N'3', N'44,45', N'2023-01-11 15:36:28.987', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 14:02:08.593', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'5415dc29-c42c-4d1b-b504-9bb299d60b87', N'暂停任务', N'QuartzAction:PauseJob', N'29', N'3', N'', N'34', N'', N'3', N'27,29', N'2023-01-05 14:41:39.603', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:44:03.247', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'5c4943a1-a579-429d-9e91-8c8cbabf9b8e', N'角色批量删除', N'SystemManagerAction:DeleteByIds', N'3', N'3', NULL, N'13', NULL, N'3', N'1,3', N'2022-12-12 14:59:59.987', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 14:59:59.987', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'6240bf1f-7fef-4141-96ac-d1b934c4c935', N'分配权限', N'SystemManagerAction:UpdatePowerIdsById', N'3', N'3', NULL, N'15', NULL, N'3', N'1,3', N'2022-12-12 15:01:14.380', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 16:41:25.340', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'658e1f80-332e-452b-9469-a8c4dee233b8', N'获取日志记录', N'QuartzAction:QueryLogList', N'29', N'3', N'', N'36', N'', N'3', N'27,29', N'2023-01-05 14:42:34.297', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:43:51.007', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'6faa59b0-6f43-4f6a-99ad-ce3be048f86d', N'添加子项', N'SystemManagerAction:Insert:Children', N'4', N'3', NULL, N'26', NULL, N'3', N'1,4', N'2022-12-12 16:49:37.213', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 16:49:37.213', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'7a81894c-0ce6-4c9a-b51f-93c869c4e8dc', N'数据管理', N'', N'0', N'1', N'', N'44', N'', N'1', N'', N'2023-01-11 15:33:48.220', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 14:02:08.600', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'80b56f52-2e45-4f1d-8947-c9a94ff7c270', N'删除', N'QuartzAction:DeleteJob', N'29', N'3', N'', N'32', N'', N'3', N'27,29', N'2023-01-05 14:40:53.900', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:43:42.160', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'84e9d9d3-cc11-44fa-81e3-4b34116b505e', N'获取异常信息', N'QuartzAction:GetException', N'29', N'3', N'', N'35', N'', N'3', N'27,29', N'2023-01-05 14:42:08.520', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:43:56.547', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'876524f2-cd75-479f-b32c-b06c8b5a0c1f', N'用户批量删除', N'SystemManagerAction:BatchDelete', N'2', N'3', NULL, N'7', NULL, N'3', N'1,2', N'2022-12-12 14:54:11.450', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 14:54:11.450', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'8bc4f48b-f294-4cdb-9751-7288b0332656', N'11', N'11', N'0', N'1', N'', N'38', N'', N'1', N'', N'2023-01-05 15:50:09.170', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 15:50:21.403', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'8c0427b1-3d11-4357-a927-c4412af6e0d4', N'系统管理', N'', N'0', N'1', N'', N'1', N'', N'1', N'', N'2022-12-12 14:44:09.997', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-02-03 13:36:32.077', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1', N'1', N'')
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'97f5bc40-ed16-4fc1-8c3e-cd3e88f5fee6', N'首页', N'', N'0', N'2', N'layui-icon-home', N'20', N'/Home/Index', N'1', N'', N'2022-12-12 15:07:12.027', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-13 10:49:16.813', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'9df53242-0499-40ae-982e-afdf3460fcd0', N'创建数据库', N'SystemManagerAction:CreateDataBase', N'45', N'3', N'', N'46', N'', N'3', N'44,45', N'2023-01-11 15:35:28.597', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 14:02:07.283', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'a3b238e4-c0e7-47c0-b587-96062017e32e', N'用户列表-查看', N'SystemManagerAction:QueryPagesUsers,SystemManagerAction:QueryRolesByUserId', N'2', N'4', N'', N'23', N'', N'3', N'1,2', N'2022-12-12 16:36:44.873', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-05 14:36:26.427', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'a86ff464-b747-412c-ac58-a4df883facc5', N'设置超级管理员', N'SystemManagerAction:UpdateIsAdminById', N'2', N'3', NULL, N'9', NULL, N'3', N'1,2', N'2022-12-12 14:55:21.550', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 14:55:21.550', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'bad1cd40-55d9-4cda-9ed9-c062d141da5c', N'测试邮箱', N'QuartzAction:TestEmail', N'40', N'3', N'', N'43', N'', N'3', N'27,40', N'2023-01-11 15:32:50.123', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 11:07:56.873', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'c355de82-68b7-446b-b670-3112adf8723d', N'系统功能', N'SystemManagerAction:QueryMenuList,HomeAction:GetCurrentUser;homeaction:logout,HomeAction:TokenHealthy,systemmanageraction:getuserinfo,homeaction:unlock,configaction:getuserconfig', N'0', N'4', N'', N'49', N'', N'1', N'', N'2023-01-12 09:33:44.117', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-02-03 13:13:01.887', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'c3be8053-ad36-41c5-8bcc-3593c6777bf0', N'测试方法', N'', N'20', N'3', N'', N'21', N'', N'2', N'20', N'2022-12-12 15:52:21.277', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-12 09:32:56.300', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'c84c4d4d-d06f-40d7-9011-bb368fc54ab2', N'数据处理', N'', N'44', N'2', N'', N'45', N'/database/index', N'2', N'44', N'2023-01-11 15:34:16.870', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 14:02:08.600', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'cea40a76-18eb-4cf7-99e7-d3a105941739', N'角色修改', N'SystemManagerAction:Update', N'3', N'3', NULL, N'14', NULL, N'3', N'1,3', N'2022-12-12 15:00:27.303', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 15:00:27.303', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'd16dd9cf-33c4-4a27-af6a-b90fbde69148', N'恢复任务', N'QuartzAction:ResumeJob', N'29', N'3', N'', N'33', N'', N'3', N'27,29', N'2023-01-05 14:41:15.447', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 14:43:46.217', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'd592ec4e-b7e4-4ce5-a56c-b207b8b61810', N'调度任务管理', N'', N'0', N'1', N'layui-icon-time', N'27', N'', N'1', N'', N'2023-01-05 14:31:45.987', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-12 17:21:25.687', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'de791d6f-7360-48ff-bf9c-2936733adaef', N'任务列表', N'', N'27', N'2', N'', N'29', N'/Quartz/QuartzList', N'2', N'27', N'2023-01-05 14:37:55.127', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-12 17:21:25.697', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'e1d768c5-2100-499f-abb2-fce3026f498b', N'添加权限', N'SystemManagerAction:InsertPower', N'4', N'3', NULL, N'16', NULL, N'3', N'1,4', N'2022-12-12 15:03:17.153', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 15:03:17.153', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'e5b43e79-7f05-4a7f-ab20-e3d62832656d', N'启用/禁用权限', N'SystemManagerAction:UpdateMenuEnable', N'4', N'3', N'', N'53', N'', N'3', N'1,4', N'2023-01-13 11:48:51.853', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-13 11:48:51.853', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'e8158d75-5517-4d89-95e8-545ae74c097a', N'用户组列表', N'', N'1', N'2', N'layui-icon-group', N'3', N'/SystemManager/RolesList', N'2', N'1', N'2022-12-12 14:47:06.807', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-30 09:53:21.230', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'f0c3ffd8-fcc1-449c-9c95-f492c2e725fd', N'必有功能', N'SystemManagerAction:QueryMenuList;HomeAction:GetCurrentUser', N'49', N'4', N'', N'50', N'', N'2', N'49', N'2023-01-12 09:34:30.300', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-12 09:37:44.340', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'f2b6dda4-0bae-4e9a-84fa-827b8282093f', N'调度配置', N'', N'27', N'2', N'layui-icon-set', N'40', N'/quartz/quartzConfig', N'2', N'27', N'2023-01-11 15:24:41.100', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-12 17:21:25.697', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'f8b2ea3a-4a9d-43d4-9d50-4c4f4083eb24', N'保存', N'ConfigAction:OperationConfig', N'40', N'4', N'', N'42', N'', N'3', N'27,40', N'2023-01-11 15:32:23.443', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-02-03 13:13:18.147', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'fef31dd4-43df-4baa-833c-9740af1409d7', N'分配角色', N'SystemManagerAction:UpdateRoleIdsById', N'2', N'3', NULL, N'10', NULL, N'3', N'1,2', N'2022-12-12 14:56:02.487', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2022-12-12 16:38:41.847', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'0', N'0', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_power] ([ID], [Name], [MenuCode], [ParentID], [PowerType], [IconUrl], [Sort], [LineUrl], [Level], [Path], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [IsMenuShow], [IsEnable], [Descript]) VALUES (N'ffc17e6f-6531-4f65-8da8-b5485c29130a', N'添加用户', N'SystemManagerAction:AddUser', N'2', N'3', NULL, N'5', NULL, N'3', N'1,2', N'2022-12-12 14:53:03.653', N'8efeed55-aef1-4212-bdf4-2779bdb37366', N'2023-01-13 11:45:51.760', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'0', N'1', NULL)
GO


-- ----------------------------
-- Table structure for lanbt_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[lanbt_role]') AND type IN ('U'))
	DROP TABLE [dbo].[lanbt_role]
GO

CREATE TABLE [dbo].[lanbt_role] (
  [ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModificaTime] datetime  NOT NULL,
  [ModifiedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IsDelete] bit  NOT NULL,
  [PowerIds] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[lanbt_role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_role',
'COLUMN', N'Name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限Id，多个英文逗号隔开',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_role',
'COLUMN', N'PowerIds'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户角色',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_role'
GO


-- ----------------------------
-- Records of lanbt_role
-- ----------------------------
INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'0ee42dae-e931-4d96-8509-d52001b274af', N'11', N'2023-01-05 15:38:10.353', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 15:44:50.167', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'113f5a0c-4e20-4470-92f8-463e194893ad', N'测试1', N'2023-01-13 15:52:23.190', N'196415df-c24b-4718-8242-261a38f8366b', N'2023-01-13 15:52:46.117', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'1,2,5,6,7,8,9,10,23,3,11,12,13,14,15,24,4,16,17,18,19,25,26,52,53,20,51,27,29,28,30,31,32,33,34,35,36,40,41,42,43,44,45,46,47,48,49')
GO

INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'2871a1e6-a6b5-4eb7-82c7-903c504941b1', N'333', N'2022-12-06 15:42:44.220', NULL, N'2023-01-05 15:36:03.603', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', N'20,21,22')
GO

INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'2f1fe7df-da77-4cf7-a5fe-67061fe60a28', N'系统管理员', N'2022-12-05 14:07:01.237', NULL, N'2023-01-13 16:06:15.520', N'196415df-c24b-4718-8242-261a38f8366b', N'0', N'1,2,5,6,7,8,9,10,23,3,11,12,13,14,15,24,4,16,17,18,19,25,26,52,53,20,51,27,29,28,30,31,32,33,34,35,36,40,41,42,43,44,45,46,47,48,49')
GO

INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'46ae5490-08a1-4988-8114-a0f976099f58', N'人事', N'2022-12-06 15:40:39.613', NULL, N'2023-01-12 09:37:54.320', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0', N'1,2,5,6,7,8,10,23,3,24,4,25,20,27,29,28,30,31,32,33,34,35,36,40,41,42,43,44,45,46,47,48,49')
GO

INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'83001908-fdd7-404c-823a-ed093e5b2515', N'22ss', N'2023-01-05 15:38:12.580', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 15:44:50.167', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'a93abead-e0bd-4510-b67d-d07ba1f75b60', N'33', N'2023-01-05 15:38:14.723', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 15:44:46.493', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', NULL)
GO

INSERT INTO [dbo].[lanbt_role] ([ID], [Name], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete], [PowerIds]) VALUES (N'adaad875-6be3-412d-a4c4-1e2a16143784', N'123', N'2023-01-05 15:38:04.707', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-01-05 15:38:07.217', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'1', NULL)
GO


-- ----------------------------
-- Table structure for LANBT_SCHEDULER_STATE
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_SCHEDULER_STATE]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_SCHEDULER_STATE]
GO

CREATE TABLE [dbo].[LANBT_SCHEDULER_STATE] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [INSTANCE_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [LAST_CHECKIN_TIME] bigint  NOT NULL,
  [CHECKIN_INTERVAL] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[LANBT_SCHEDULER_STATE] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SCHEDULER_STATE',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'实例名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SCHEDULER_STATE',
'COLUMN', N'INSTANCE_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后验证时间',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SCHEDULER_STATE',
'COLUMN', N'LAST_CHECKIN_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'时间间隔',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SCHEDULER_STATE',
'COLUMN', N'CHECKIN_INTERVAL'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度器状态。',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SCHEDULER_STATE'
GO


-- ----------------------------
-- Records of LANBT_SCHEDULER_STATE
-- ----------------------------
INSERT INTO [dbo].[LANBT_SCHEDULER_STATE] ([SCHED_NAME], [INSTANCE_NAME], [LAST_CHECKIN_TIME], [CHECKIN_INTERVAL]) VALUES (N'QuartzScheduler', N'NON_CLUSTERED', N'638072136200617643', N'7500')
GO


-- ----------------------------
-- Table structure for LANBT_SIMPLE_TRIGGERS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_SIMPLE_TRIGGERS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_SIMPLE_TRIGGERS]
GO

CREATE TABLE [dbo].[LANBT_SIMPLE_TRIGGERS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [REPEAT_COUNT] int  NOT NULL,
  [REPEAT_INTERVAL] bigint  NOT NULL,
  [TIMES_TRIGGERED] int  NOT NULL
)
GO

ALTER TABLE [dbo].[LANBT_SIMPLE_TRIGGERS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPLE_TRIGGERS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPLE_TRIGGERS',
'COLUMN', N'TRIGGER_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPLE_TRIGGERS',
'COLUMN', N'TRIGGER_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'重复次数',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPLE_TRIGGERS',
'COLUMN', N'REPEAT_COUNT'
GO

EXEC sp_addextendedproperty
'MS_Description', N'重复间隔',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPLE_TRIGGERS',
'COLUMN', N'REPEAT_INTERVAL'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发次数',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPLE_TRIGGERS',
'COLUMN', N'TIMES_TRIGGERED'
GO


-- ----------------------------
-- Records of LANBT_SIMPLE_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for LANBT_SIMPROP_TRIGGERS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_SIMPROP_TRIGGERS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_SIMPROP_TRIGGERS]
GO

CREATE TABLE [dbo].[LANBT_SIMPROP_TRIGGERS] (
  [SCHED_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_GROUP] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [STR_PROP_1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [STR_PROP_2] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [STR_PROP_3] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [INT_PROP_1] int  NULL,
  [INT_PROP_2] int  NULL,
  [LONG_PROP_1] bigint  NULL,
  [LONG_PROP_2] bigint  NULL,
  [DEC_PROP_1] decimal(18,4)  NULL,
  [DEC_PROP_2] decimal(18,4)  NULL,
  [BOOL_PROP_1] bit  NULL,
  [BOOL_PROP_2] bit  NULL,
  [TIME_ZONE_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[LANBT_SIMPROP_TRIGGERS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPROP_TRIGGERS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPROP_TRIGGERS',
'COLUMN', N'TRIGGER_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPROP_TRIGGERS',
'COLUMN', N'TRIGGER_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存储CalendarIntervalTrigger和DailyTimeIntervalTrigger两种类型的触发器',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_SIMPROP_TRIGGERS'
GO


-- ----------------------------
-- Records of LANBT_SIMPROP_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for lanbt_system_config
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[lanbt_system_config]') AND type IN ('U'))
	DROP TABLE [dbo].[lanbt_system_config]
GO

CREATE TABLE [dbo].[lanbt_system_config] (
  [ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Key] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Value] varchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModificaTime] datetime  NOT NULL,
  [ModifiedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IsDelete] bit  NOT NULL
)
GO

ALTER TABLE [dbo].[lanbt_system_config] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'键',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_config',
'COLUMN', N'Key'
GO

EXEC sp_addextendedproperty
'MS_Description', N'值',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_config',
'COLUMN', N'Value'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统配置',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_config'
GO


-- ----------------------------
-- Records of lanbt_system_config
-- ----------------------------
INSERT INTO [dbo].[lanbt_system_config] ([ID], [Key], [Value], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete]) VALUES (N'00380886-96ed-4054-b5b6-d15024891ff7', N'config:system:lanbt.system.email.config', N'{"is_mail_enable":"true","mail_server_addr":"smtp.163.com","mail_server_port":"465","is_mail_ssl_enable":"true","send_mail_name":"烂笔头管理员","send_mailbox":"123123@163.com","mail_code":"123123123","receiv_mail":"123123@qq.com"}', N'2023-01-09 17:09:50.330', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-02-03 14:21:16.870', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0')
GO


-- ----------------------------
-- Table structure for lanbt_system_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[lanbt_system_log]') AND type IN ('U'))
	DROP TABLE [dbo].[lanbt_system_log]
GO

CREATE TABLE [dbo].[lanbt_system_log] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [CreateTime] datetime  NULL,
  [Level] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Logger] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Message] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [Exception] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[lanbt_system_log] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_log',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'级别',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_log',
'COLUMN', N'Level'
GO

EXEC sp_addextendedproperty
'MS_Description', N'日志对象类',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_log',
'COLUMN', N'Logger'
GO

EXEC sp_addextendedproperty
'MS_Description', N'错误信息',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_log',
'COLUMN', N'Message'
GO

EXEC sp_addextendedproperty
'MS_Description', N'错误对象',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_log',
'COLUMN', N'Exception'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统日志',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_system_log'
GO


-- ----------------------------
-- Records of lanbt_system_log
-- ----------------------------
SET IDENTITY_INSERT [dbo].[lanbt_system_log] ON
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12782', N'2023-01-13 17:24:25.087', N'Warn', N'Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository', N'Using an in-memory repository. Keys will not be persisted to storage.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12783', N'2023-01-13 17:24:25.317', N'Warn', N'Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager', N'Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12784', N'2023-01-13 17:24:25.330', N'Warn', N'Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager', N'No XML encryptor configured. Key {5d61efd2-a679-492e-b56e-021740a74491} may be persisted to storage in unencrypted form.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12785', N'2023-01-13 17:24:25.447', N'Warn', N'Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware', N'Failed to determine the https port for redirect.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12786', N'2023-01-13 17:28:13.790', N'Warn', N'Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository', N'Using an in-memory repository. Keys will not be persisted to storage.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12787', N'2023-01-13 17:28:14.000', N'Warn', N'Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager', N'Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12788', N'2023-01-13 17:28:14.000', N'Warn', N'Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager', N'No XML encryptor configured. Key {d7bacce9-0f33-4819-a565-39666fef4acd} may be persisted to storage in unencrypted form.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12789', N'2023-01-13 17:28:14.123', N'Warn', N'Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware', N'Failed to determine the https port for redirect.', N'')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12790', N'2023-01-28 13:57:37.263', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Microsoft.Data.SqlClient.SqlException: 列名 ''IconUrl'' 无效。', N'Microsoft.Data.SqlClient.SqlException (0x80131904): 列名 ''IconUrl'' 无效。
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters)
   at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj)
   at SqlSugar.QueryableProvider`1._ToListAsync[TResult]()
   at SqlSugar.QueryableProvider`1.FirstAsync()
   at SqlSugar.QueryableProvider`1.FirstAsync(Expression`1 expression)
   at Lanbt.Core.Repository.SqlService.RepositoryBase`1.FirstOrDefault(Expression`1 where, Boolean isAll) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Repository\SqlService\RepositoryBase.cs:line 81
   at Lanbt.Core.Service.SqlService.UserService.GetUserById(String id) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 83
   at Lanbt.Core.Web.Controllers.Action.HomeAction.GetCurrentUser() in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\HomeAction.cs:line 114
   at lambda_method41(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
ClientConnectionId:ffcb5dcb-ddc6-4b80-9205-5b1ea0255494
Error Number:207,State:1,Class:16')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12791', N'2023-01-28 13:57:37.337', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Microsoft.Data.SqlClient.SqlException: 列名 ''IconUrl'' 无效。', N'Microsoft.Data.SqlClient.SqlException (0x80131904): 列名 ''IconUrl'' 无效。
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters)
   at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj)
   at SqlSugar.QueryableProvider`1._ToListAsync[TResult]()
   at SqlSugar.QueryableProvider`1.FirstAsync()
   at SqlSugar.QueryableProvider`1.FirstAsync(Expression`1 expression)
   at Lanbt.Core.Repository.SqlService.RepositoryBase`1.FirstOrDefault(Expression`1 where, Boolean isAll) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Repository\SqlService\RepositoryBase.cs:line 81
   at Lanbt.Core.Service.SqlService.UserService.GetUserById(String id) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 83
   at Lanbt.Core.Service.SqlService.ServiceBase.GetCurrentUserInfo() in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\ServiceBase.cs:line 44
   at Lanbt.Core.Service.SqlService.PowerService.QueryMenuList() in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\PowerService.cs:line 175
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.QueryMenuList() in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 286
   at lambda_method67(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
ClientConnectionId:ffcb5dcb-ddc6-4b80-9205-5b1ea0255494
Error Number:207,State:1,Class:16')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12792', N'2023-01-28 13:58:15.927', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Microsoft.Data.SqlClient.SqlException: 列名 ''IconUrl'' 无效。', N'Microsoft.Data.SqlClient.SqlException (0x80131904): 列名 ''IconUrl'' 无效。
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters)
   at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj)
   at SqlSugar.QueryableProvider`1._ToListAsync[TResult]()
   at SqlSugar.QueryableProvider`1.FirstAsync()
   at SqlSugar.QueryableProvider`1.FirstAsync(Expression`1 expression)
   at Lanbt.Core.Repository.SqlService.RepositoryBase`1.FirstOrDefault(Expression`1 where, Boolean isAll) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Repository\SqlService\RepositoryBase.cs:line 81
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 39
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 70
   at lambda_method82(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
ClientConnectionId:ffcb5dcb-ddc6-4b80-9205-5b1ea0255494
Error Number:207,State:1,Class:16')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12793', N'2023-01-28 13:58:51.383', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Microsoft.Data.SqlClient.SqlException: 列名 ''IconUrl'' 无效。', N'Microsoft.Data.SqlClient.SqlException (0x80131904): 列名 ''IconUrl'' 无效。
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters)
   at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj)
   at SqlSugar.QueryableProvider`1._ToListAsync[TResult]()
   at SqlSugar.QueryableProvider`1.FirstAsync()
   at SqlSugar.QueryableProvider`1.FirstAsync(Expression`1 expression)
   at Lanbt.Core.Repository.SqlService.RepositoryBase`1.FirstOrDefault(Expression`1 where, Boolean isAll) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Repository\SqlService\RepositoryBase.cs:line 81
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 39
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 70
   at lambda_method82(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
ClientConnectionId:ffcb5dcb-ddc6-4b80-9205-5b1ea0255494
Error Number:207,State:1,Class:16')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12794', N'2023-01-28 13:58:54.017', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Microsoft.Data.SqlClient.SqlException: 列名 ''IconUrl'' 无效。', N'Microsoft.Data.SqlClient.SqlException (0x80131904): 列名 ''IconUrl'' 无效。
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__208_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters)
   at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj)
   at SqlSugar.QueryableProvider`1._ToListAsync[TResult]()
   at SqlSugar.QueryableProvider`1.FirstAsync()
   at SqlSugar.QueryableProvider`1.FirstAsync(Expression`1 expression)
   at Lanbt.Core.Repository.SqlService.RepositoryBase`1.FirstOrDefault(Expression`1 where, Boolean isAll) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Repository\SqlService\RepositoryBase.cs:line 81
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 39
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 70
   at lambda_method82(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
ClientConnectionId:ffcb5dcb-ddc6-4b80-9205-5b1ea0255494
Error Number:207,State:1,Class:16')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12795', N'2023-01-28 14:00:10.680', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: lanbt_user 创建失败,请认真检查 1、属性需要get set 2、特殊类型需要加Ignore 具体错误内容： ALTER TABLE 只允许添加满足下述条件的列: 列可以包含 Null 值；或者列具有指定的 DEFAULT 定义；或者要添加的列是标识列或时间戳列；或者，如果前几个条件均未满足，则表必须为空以允许添加此列。不能将列“IconUrl”添加到非空表“lanbt_user”中，因为它不满足上述条件。', N'System.Exception: lanbt_user 创建失败,请认真检查 1、属性需要get set 2、特殊类型需要加Ignore 具体错误内容： ALTER TABLE 只允许添加满足下述条件的列: 列可以包含 Null 值；或者列具有指定的 DEFAULT 定义；或者要添加的列是标识列或时间戳列；或者，如果前几个条件均未满足，则表必须为空以允许添加此列。不能将列“IconUrl”添加到非空表“lanbt_user”中，因为它不满足上述条件。
   at SqlSugar.CodeFirstProvider.InitTables(Type[] entityTypes)
   at Lanbt.Core.Repository.SqlService.DatabaseRepository.CreateTables() in D:\LearnProject\Lanbt.Core\Lanbt.Core.Repository\SqlService\DatabaseRepository.cs:line 46
   at Lanbt.Core.Service.SqlService.DatabaseService.CreateTables() in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\DatabaseService.cs:line 18
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.CreateTables() in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 385
   at lambda_method30(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12796', N'2023-01-29 10:57:47.387', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 参数错误：名称不能为空', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 参数错误：名称不能为空
   at Lanbt.Core.Service.SqlService.UserService.Update(UpdateUserInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 317
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdateUser(UpdateUserInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 133
   at lambda_method170(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12797', N'2023-01-29 13:24:05.967', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12798', N'2023-01-29 13:24:14.953', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12799', N'2023-01-29 13:33:27.857', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12800', N'2023-01-29 13:33:30.207', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12801', N'2023-01-29 13:33:31.623', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12802', N'2023-01-29 13:33:37.487', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12803', N'2023-01-29 13:33:41.600', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12804', N'2023-01-29 13:37:04.237', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12805', N'2023-01-29 13:37:09.127', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误', N'Lanbt.Core.Utility.ExceptionExtent.LanbtException: 警告：密码错误
   at Lanbt.Core.Service.SqlService.UserService.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 364
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.UpdatePassword(UpdatePasswordInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 156
   at lambda_method141(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12806', N'2023-01-29 13:37:21.447', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: 密码错误，请重新输入', N'System.Exception: 密码错误，请重新输入
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 49
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 80
   at lambda_method193(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12807', N'2023-01-29 13:37:30.230', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: 密码错误，请重新输入', N'System.Exception: 密码错误，请重新输入
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 49
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 80
   at lambda_method193(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12808', N'2023-01-29 13:39:21.633', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: 密码错误，请重新输入', N'System.Exception: 密码错误，请重新输入
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 49
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 80
   at lambda_method193(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12809', N'2023-01-29 18:02:01.667', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: 密码错误，请重新输入', N'System.Exception: 密码错误，请重新输入
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 49
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 80
   at lambda_method182(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12810', N'2023-01-29 18:02:04.383', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: 密码错误，请重新输入', N'System.Exception: 密码错误，请重新输入
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 49
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 80
   at lambda_method182(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12811', N'2023-01-30 09:52:17.703', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: 密码错误，请重新输入', N'System.Exception: 密码错误，请重新输入
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 49
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 80
   at lambda_method51(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12812', N'2023-02-03 09:33:16.900', N'Error', N'Lanbt.Core.Web.Filter.GlobalExceptionFilter', N'System.Exception: 密码错误，请重新输入', N'System.Exception: 密码错误，请重新输入
   at Lanbt.Core.Service.SqlService.UserService.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Service\SqlService\UserService.cs:line 49
   at Lanbt.Core.Web.Controllers.Action.SystemManagerAction.Input(LoginInput input) in D:\LearnProject\Lanbt.Core\Lanbt.Core.Web\Controllers\Action\SystemManagerAction.cs:line 80
   at lambda_method51(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)')
GO

INSERT INTO [dbo].[lanbt_system_log] ([Id], [CreateTime], [Level], [Logger], [Message], [Exception]) VALUES (N'12813', N'2023-02-03 11:02:36.933', N'Fatal', N'Microsoft.AspNetCore.Server.Kestrel', N'Connection id "0HMO5GQ9G5NR0" application never completed.', N'')
GO

SET IDENTITY_INSERT [dbo].[lanbt_system_log] OFF
GO


-- ----------------------------
-- Table structure for LANBT_TRIGGERS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[LANBT_TRIGGERS]') AND type IN ('U'))
	DROP TABLE [dbo].[LANBT_TRIGGERS]
GO

CREATE TABLE [dbo].[LANBT_TRIGGERS] (
  [SCHED_NAME] varchar(120) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_NAME] varchar(150) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_GROUP] varchar(150) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [JOB_NAME] varchar(150) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [JOB_GROUP] varchar(150) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DESCRIPTION] varchar(250) COLLATE Chinese_PRC_CI_AS  NULL,
  [NEXT_FIRE_TIME] bigint  NULL,
  [PREV_FIRE_TIME] bigint  NULL,
  [PRIORITY] int  NULL,
  [TRIGGER_STATE] varchar(16) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TRIGGER_TYPE] varchar(8) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [START_TIME] bigint  NOT NULL,
  [END_TIME] bigint  NULL,
  [CALENDAR_NAME] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [MISFIRE_INSTR] int  NULL,
  [JOB_DATA] varbinary(max)  NULL
)
GO

ALTER TABLE [dbo].[LANBT_TRIGGERS] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'SCHED_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'TRIGGER_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'TRIGGER_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'JOB_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务组',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'JOB_GROUP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'说明',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'DESCRIPTION'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下次执行时间',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'NEXT_FIRE_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'上次执行时间',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'PREV_FIRE_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'线程优先级',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'PRIORITY'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发状态此字段很重要',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'TRIGGER_STATE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'触发器类型',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'TRIGGER_TYPE'
GO

EXEC sp_addextendedproperty
'MS_Description', N'开始时间',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'START_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'结束时间',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'END_TIME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'日历名称',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'CALENDAR_NAME'
GO

EXEC sp_addextendedproperty
'MS_Description', N'失配_中断',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'MISFIRE_INSTR'
GO

EXEC sp_addextendedproperty
'MS_Description', N'作业_数据',
'SCHEMA', N'dbo',
'TABLE', N'LANBT_TRIGGERS',
'COLUMN', N'JOB_DATA'
GO


-- ----------------------------
-- Records of LANBT_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for lanbt_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[lanbt_user]') AND type IN ('U'))
	DROP TABLE [dbo].[lanbt_user]
GO

CREATE TABLE [dbo].[lanbt_user] (
  [ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [UserName] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Password] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Mobile] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Email] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateTime] datetime  NOT NULL,
  [ModificaTime] datetime  NOT NULL,
  [IsDelete] bit  NOT NULL,
  [IsAdmin] bit  NOT NULL,
  [RoleIds] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreatedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifiedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [HeadUrl] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[lanbt_user] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'Name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'UserName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'Password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机号',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'Mobile'
GO

EXEC sp_addextendedproperty
'MS_Description', N'邮箱',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'Email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否是超级管理员',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'IsAdmin'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色ids',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'RoleIds'
GO

EXEC sp_addextendedproperty
'MS_Description', N'头像',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user',
'COLUMN', N'HeadUrl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统用户',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user'
GO


-- ----------------------------
-- Records of lanbt_user
-- ----------------------------
INSERT INTO [dbo].[lanbt_user] ([ID], [Name], [UserName], [Password], [Mobile], [Email], [CreateTime], [ModificaTime], [IsDelete], [IsAdmin], [RoleIds], [CreatedId], [ModifiedId], [HeadUrl]) VALUES (N'196415df-c24b-4718-8242-261a38f8366b', N'测试01', N'ceshi01', N'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, N'2022-12-12 17:43:32.563', N'2023-01-30 09:53:51.517', N'0', N'0', N'2f1fe7df-da77-4cf7-a5fe-67061fe60a28', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', NULL)
GO

INSERT INTO [dbo].[lanbt_user] ([ID], [Name], [UserName], [Password], [Mobile], [Email], [CreateTime], [ModificaTime], [IsDelete], [IsAdmin], [RoleIds], [CreatedId], [ModifiedId], [HeadUrl]) VALUES (N'5f10696d-ef0b-457f-bd2c-bf4978972a84', N'测试02', N'ceshi02', N'e10adc3949ba59abbe56e057f20f883e', N'', N'', N'2023-01-05 17:34:38.250', N'2023-01-05 17:34:43.690', N'1', N'0', NULL, N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', NULL)
GO

INSERT INTO [dbo].[lanbt_user] ([ID], [Name], [UserName], [Password], [Mobile], [Email], [CreateTime], [ModificaTime], [IsDelete], [IsAdmin], [RoleIds], [CreatedId], [ModifiedId], [HeadUrl]) VALUES (N'cad0fbed-5d2e-47b2-97a0-b34643aa5c5e', N'测试账号02', N'ceshi02', N'e10adc3949ba59abbe56e057f20f883e', N'', N'', N'2023-01-13 15:51:58.613', N'2023-01-13 15:52:54.490', N'0', N'0', N'2f1fe7df-da77-4cf7-a5fe-67061fe60a28', N'196415df-c24b-4718-8242-261a38f8366b', N'196415df-c24b-4718-8242-261a38f8366b', NULL)
GO

INSERT INTO [dbo].[lanbt_user] ([ID], [Name], [UserName], [Password], [Mobile], [Email], [CreateTime], [ModificaTime], [IsDelete], [IsAdmin], [RoleIds], [CreatedId], [ModifiedId], [HeadUrl]) VALUES (N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'超级管理员', N'admin', N'db7f9e99b8c094b24dfa315fa7ffac98', N'', N'', N'2022-12-12 17:42:21.733', N'2023-02-03 14:14:20.830', N'0', N'1', NULL, NULL, N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', NULL)
GO


-- ----------------------------
-- Table structure for lanbt_user_config
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[lanbt_user_config]') AND type IN ('U'))
	DROP TABLE [dbo].[lanbt_user_config]
GO

CREATE TABLE [dbo].[lanbt_user_config] (
  [ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [UserId] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Key] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Value] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateTime] datetime  NOT NULL,
  [CreatedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModificaTime] datetime  NOT NULL,
  [ModifiedId] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IsDelete] bit  NOT NULL
)
GO

ALTER TABLE [dbo].[lanbt_user_config] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user_config',
'COLUMN', N'UserId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'键',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user_config',
'COLUMN', N'Key'
GO

EXEC sp_addextendedproperty
'MS_Description', N'值',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user_config',
'COLUMN', N'Value'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户设置',
'SCHEMA', N'dbo',
'TABLE', N'lanbt_user_config'
GO


-- ----------------------------
-- Records of lanbt_user_config
-- ----------------------------
INSERT INTO [dbo].[lanbt_user_config] ([ID], [UserId], [Key], [Value], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete]) VALUES (N'c8036ec9-129a-4c17-88b6-7d85c661ed42', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'config:user:lanbt.user.setting.config', N'{"screen_password":"123123"}', N'2023-02-03 13:18:38.797', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'2023-02-03 13:19:04.733', N'df297dd7-d249-43a3-9e30-5f0f0ea3ee04', N'0')
GO

INSERT INTO [dbo].[lanbt_user_config] ([ID], [UserId], [Key], [Value], [CreateTime], [CreatedId], [ModificaTime], [ModifiedId], [IsDelete]) VALUES (N'e4a34805-3655-405c-b7fe-095e21de4aa9', N'196415df-c24b-4718-8242-261a38f8366b', N'config:user:lanbt.user.setting.config', N'{"screen_password":"123123"}', N'2023-02-03 13:17:36.980', N'196415df-c24b-4718-8242-261a38f8366b', N'2023-02-03 13:18:09.300', N'196415df-c24b-4718-8242-261a38f8366b', N'0')
GO


-- ----------------------------
-- Primary Key structure for table lanbt_power
-- ----------------------------
ALTER TABLE [dbo].[lanbt_power] ADD CONSTRAINT [PK_lanbt_power_ID] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table lanbt_role
-- ----------------------------
ALTER TABLE [dbo].[lanbt_role] ADD CONSTRAINT [PK_lanbt_role_ID] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table lanbt_system_config
-- ----------------------------
ALTER TABLE [dbo].[lanbt_system_config] ADD CONSTRAINT [PK_lanbt_system_config_ID] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for lanbt_system_log
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[lanbt_system_log]', RESEED, 12813)
GO


-- ----------------------------
-- Primary Key structure for table lanbt_system_log
-- ----------------------------
ALTER TABLE [dbo].[lanbt_system_log] ADD CONSTRAINT [PK_lanbt_system_log_Id] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table lanbt_user
-- ----------------------------
ALTER TABLE [dbo].[lanbt_user] ADD CONSTRAINT [PK_lanbt_user_ID] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table lanbt_user_config
-- ----------------------------
ALTER TABLE [dbo].[lanbt_user_config] ADD CONSTRAINT [PK_lanbt_user_config_ID] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

